This AgileShape can be used to delete multiple existing database records in a database table.
NOTE: This AgileShape is a specialized sub-type of the AgilePart AgileShape. Refer to the documentation for the AgilePart AgileShape for additional information about the properties and behavior that this sub-type inherits from the AgilePart AgileShape.
Design-Time Properties
NOTE: Since this AgileShape is a specialized sub-type of the AgilePart AgileShape, all of the standard properties supported by the AgilePart AgileShape are also supported by this AgileShape. Since they are already documented elsewhere, the standard AgilePart properties are not documented in this section. Refer to the documentation for the AgilePart AgileShape for information about the standard AgilePart properties. Additional design-time properties (other than the standard AgilePart properties) that are specific to this AgileShape are documented below.
Configure
This property allows the process modeler to configure where and how the new database records are inserted into the database.
NOTE: Changes made to this property’s configuration may also update the values of the ConnectionString, TableName, and/or Where properties. Click the Ellipsesbutton to open the Configuration for Deleting Database Record(s) dialog (as shown below).
ConnectionString
NOTE: This property can only be updated via the Configure property. See that property for additional information. The connection string that will be used to connect to the database at runtime.
DatabaseType
The type of database that will be used.
Debug
Default value: True
This property determines whether the AgileShape will log additional progress and debugging messages to the AgilePoint Server log file at runtime. This property can be set to the following specific values:
- False
This value indicates that the AgileShape will not log additional progress and debugging messages to the AgilePoint Server log file at runtime.
- True
This value indicates that the AgileShape will log additional progress and debugging messages to the AgilePoint Server log file at runtime. These messages are often helpful in verifying that the AgileShape is functioning properly and/or with troubleshooting any problems or suspected problems with the AgileShape’s runtime behavior or configuration.
TableName
NOTE: This property can only be updated via the Configure property. See that property for additional information.
The name of the database table where this AgileShape should insert the database record.
Timeout
Default value: 600
Specifies the maximum amount of time (in seconds) that should be allowed for the completion of the Web service call associated with this AgileShape.
Where
NOTE: This property can only be updated via the Configure property. See that property for additional information.
The SQL WHERE clause that defines which database records should be updated.